The Three Year Realization report shows billed WIP for the current year selected, allowing you to identify and analyze trends in client production, billings, and accounts receivable. The report considers accounts receivable adjustments in the calculation of realization percentage and effective rate.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, the comparable report is Three Year Realization (Custom Library). In Practice Advantage, there is no comparable report.
Report Specifications
The following report options and filters are available to determine the report contents.
| Options and Settings | ||
|---|---|---|
| Option | Setting | Description |
|
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
|
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
|
Select to Include Transactions Using… |
List |
Determines the type of date to use for the date range on the report. The options are Transaction Date and Accounting Period Date. |
|
Include Billable WIP Only |
Yes/No |
Includes only billable WIP on the report; otherwise, all WIP is included on the report. |
|
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information. |
| Default Filters | ||
|---|---|---|
| Field Name | Operator | Value |
| Date | Between |
First Day of Current Fiscal Year, Last Day of Current Fiscal Year |
| Optional Filters | ||
|---|---|---|
| Available Fields | ||
|
Business Code |
Client ID.Sub ID |
Date |
|
Client |
Client Name |
Financial Reporting Client Group |
|
Client – Principal |
Client Office |
Line of Business |
|
Client Bill Manager |
Client Primary Service Type |
Manager |
|
Client Billing Group |
Client Region |
Primary Partner |
|
Client Business Unit |
Client Sub ID |
Return Group |
|
Client ID |
Client Type |
Tax Type |
| Grouping | ||
|---|---|---|
| Available Fields | ||
|
Business Code |
Client ID.Sub ID |
Financial Reporting Client Group |
|
Client |
Client Name |
Line of Business |
|
Client – Principal |
Client Office |
Manager |
|
Client Bill Manager |
Client Primary Service Type |
Primary Partner |
|
Client Billing Group |
Client Region |
Return Group |
|
Client Business Unit |
Client Sub ID |
Sort Name |
|
Client ID |
Client Type |
Tax Type |
| Sorting |
|---|
| Available Field |
| Client |
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
| Report Fields | |
|---|---|
| Field | Description |
|
Year |
The year associated with the WIP entries. |
|
Production Hours |
All WIP hours posted for the date range selected (if the Include Billable WIP Only option is selected, nonbillable hours are excluded from the report). |
|
Production Amounts |
All WIP amounts posted for the date range selected, including expenses and surcharges (if the Include Billable WIP Only option is selected, nonbillable amounts are excluded from the report). |
|
Billed Hours |
The total number of hours for billed WIP on posted invoices for the date range selected. This is looking at the invoice date and not the date of the WIP transaction. |
|
Invoiced w/o Progress |
The total amount of WIP billed for the date range. The calculation is billed WIP + write up/down. This does not include sales tax or progress. |
|
Progress Bills |
The total progress billed for the period selected (excluding progress applied). |
|
Write Up/Down |
The total of write up/down. |
|
AR Adjustment |
The total credit memos, debit memos, AR write offs, credit adjustments, and debit adjustments. |
|
Real % |
The realization for the client for the date range selected. The calculation is invoiced w/o progress + AR adjustment divided by invoiced w/o progress - WIP adjustment. |
|
Eff Rate |
The effective rate for the client listed. The calculation is invoiced w/o progress + AR adjustment divided by billed hours. |
Three Year Realization Sample Report
